

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bingju
-- ----------------------------
DROP TABLE IF EXISTS `bingju`;
CREATE TABLE `bingju` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜编号',
  `bingjupinpai` varchar(200) DEFAULT NULL COMMENT '冰柜品牌',
  `bingjuguige` varchar(200) DEFAULT NULL COMMENT '冰柜规格',
  `bingjurongliang` varchar(200) DEFAULT NULL COMMENT '冰柜容量',
  `bingjuweizhi` varchar(200) DEFAULT NULL COMMENT '冰柜位置',
  `bingjubiaoqian` varchar(200) DEFAULT NULL COMMENT '冰柜标签',
  PRIMARY KEY (`id`),
  UNIQUE KEY `bingjubianhao` (`bingjubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985154674 DEFAULT CHARSET=utf8mb3 COMMENT='冰柜';

-- ----------------------------
-- Records of bingju
-- ----------------------------
BEGIN;
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (31, '2025-06-11 10:23:45', '冰柜编号1', '冰柜品牌1', '冰柜规格1', '冰柜容量1', '冰柜位置1', '冰柜标签1');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (32, '2025-06-13 15:12:08', '冰柜编号2', '冰柜品牌2', '冰柜规格2', '冰柜容量2', '冰柜位置2', '冰柜标签2');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (33, '2025-06-14 09:45:32', '冰柜编号3', '冰柜品牌3', '冰柜规格3', '冰柜容量3', '冰柜位置3', '冰柜标签3');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (34, '2025-06-15 18:22:11', '冰柜编号4', '冰柜品牌4', '冰柜规格4', '冰柜容量4', '冰柜位置4', '冰柜标签4');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (35, '2025-06-16 12:34:56', '冰柜编号5', '冰柜品牌5', '冰柜规格5', '冰柜容量5', '冰柜位置5', '冰柜标签5');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (36, '2025-06-17 08:11:29', '冰柜编号6', '冰柜品牌6', '冰柜规格6', '冰柜容量6', '冰柜位置6', '冰柜标签6');
INSERT INTO `bingju` (`id`, `addtime`, `bingjubianhao`, `bingjupinpai`, `bingjuguige`, `bingjurongliang`, `bingjuweizhi`, `bingjubiaoqian`) VALUES (1650985154673, '2025-06-18 21:59:14', '001', '美的', '100*160', '60L', '东食堂', '基于微信小程序的高校餐厅食品留样管理系统');
COMMIT;

-- ----------------------------
-- Table structure for chuangkoufuzeren
-- ----------------------------
DROP TABLE IF EXISTS `chuangkoufuzeren`;
CREATE TABLE `chuangkoufuzeren` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
  `fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
  `mima` varchar(200) DEFAULT NULL COMMENT '密码',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`),
  UNIQUE KEY `chuangkoubianhao` (`chuangkoubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985355380 DEFAULT CHARSET=utf8mb3 COMMENT='窗口负责人';

-- ----------------------------
-- Records of chuangkoufuzeren
-- ----------------------------
BEGIN;
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (11, '2025-06-10 09:12:34', '窗口编号1', '负责人1', '123456', '男', '13823888881', 'upload/chuangkoufuzeren_touxiang1.jpg', '否', '要审核通过才能登录');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (12, '2025-06-11 14:23:45', '窗口编号2', '负责人2', '123456', '男', '13823888882', 'upload/chuangkoufuzeren_touxiang2.jpg', '是', '');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (13, '2025-06-12 16:34:56', '窗口编号3', '负责人3', '123456', '男', '13823888883', 'upload/chuangkoufuzeren_touxiang3.jpg', '是', '');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (14, '2025-06-13 11:45:12', '窗口编号4', '负责人4', '123456', '男', '13823888884', 'upload/chuangkoufuzeren_touxiang4.jpg', '是', '');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (15, '2025-06-14 18:56:23', '窗口编号5', '负责人5', '123456', '男', '13823888885', 'upload/chuangkoufuzeren_touxiang5.jpg', '是', '');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (16, '2025-06-15 20:01:11', '窗口编号6', '负责人6', '123456', '男', '13823888886', 'upload/chuangkoufuzeren_touxiang6.jpg', '是', '');
INSERT INTO `chuangkoufuzeren` (`id`, `addtime`, `chuangkoubianhao`, `fuzeren`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `sfsh`, `shhf`) VALUES (1650985355379, '2025-06-16 13:02:35', '111', '胡月', '111', '女', '13612514514', 'upload/1650985478777.jpg', '是', '11');
COMMIT;

-- ----------------------------
-- Table structure for chuangkouyuangong
-- ----------------------------
DROP TABLE IF EXISTS `chuangkouyuangong`;
CREATE TABLE `chuangkouyuangong` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
  `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
  `mima` varchar(200) DEFAULT NULL COMMENT '密码',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yuangonggonghao` (`yuangonggonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985500526 DEFAULT CHARSET=utf8mb3 COMMENT='窗口员工';

-- ----------------------------
-- Records of chuangkouyuangong
-- ----------------------------
BEGIN;
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (21, '2025-06-10 08:23:45', '员工工号1', '员工姓名1', '123456', '男', '13823888881', 'upload/chuangkouyuangong_touxiang1.jpg', '窗口编号1');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (22, '2025-06-11 10:34:56', '员工工号2', '员工姓名2', '123456', '男', '13823888882', 'upload/chuangkouyuangong_touxiang2.jpg', '窗口编号2');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (23, '2025-06-12 12:45:12', '员工工号3', '员工姓名3', '123456', '男', '13823888883', 'upload/chuangkouyuangong_touxiang3.jpg', '窗口编号3');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (24, '2025-06-13 14:56:23', '员工工号4', '员工姓名4', '123456', '男', '13823888884', 'upload/chuangkouyuangong_touxiang4.jpg', '窗口编号4');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (25, '2025-06-14 16:01:11', '员工工号5', '员工姓名5', '123456', '男', '13823888885', 'upload/chuangkouyuangong_touxiang5.jpg', '窗口编号5');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (26, '2025-06-15 18:12:34', '员工工号6', '员工姓名6', '123456', '男', '13823888886', 'upload/chuangkouyuangong_touxiang6.jpg', '窗口编号6');
INSERT INTO `chuangkouyuangong` (`id`, `addtime`, `yuangonggonghao`, `yuangongxingming`, `mima`, `xingbie`, `lianxidianhua`, `touxiang`, `chuangkoubianhao`) VALUES (1650985500525, '2025-06-16 20:05:00', '222', '李继军', '222', '男', '13612512514', 'upload/1650985499959.jpg', '111');
COMMIT;

-- ----------------------------
-- Table structure for chufagonggao
-- ----------------------------
DROP TABLE IF EXISTS `chufagonggao`;
CREATE TABLE `chufagonggao` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gonggaobiaoti` varchar(200) DEFAULT NULL COMMENT '公告标题',
  `gonggaoleixing` varchar(200) DEFAULT NULL COMMENT '公告类型',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `gonggaoneirong` longtext COMMENT '公告内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985234157 DEFAULT CHARSET=utf8mb3 COMMENT='处罚公告';

-- ----------------------------
-- Records of chufagonggao
-- ----------------------------
BEGIN;
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (71, '2025-06-10 09:23:45', '公告标题1', '公告类型1', '2025-06-10', 'upload/chufagonggao_fengmian1.jpg', '公告内容1');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (72, '2025-06-11 10:34:56', '公告标题2', '公告类型2', '2025-06-11', 'upload/chufagonggao_fengmian2.jpg', '公告内容2');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (73, '2025-06-12 11:45:12', '公告标题3', '公告类型3', '2025-06-12', 'upload/chufagonggao_fengmian3.jpg', '公告内容3');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (74, '2025-06-13 12:56:23', '公告标题4', '公告类型4', '2025-06-13', 'upload/chufagonggao_fengmian4.jpg', '公告内容4');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (75, '2025-06-14 13:01:11', '公告标题5', '公告类型5', '2025-06-14', 'upload/chufagonggao_fengmian5.jpg', '公告内容5');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (76, '2025-06-15 14:12:34', '公告标题6', '公告类型6', '2025-06-15', 'upload/chufagonggao_fengmian6.jpg', '公告内容6');
INSERT INTO `chufagonggao` (`id`, `addtime`, `gonggaobiaoti`, `gonggaoleixing`, `fabushijian`, `fengmian`, `gonggaoneirong`) VALUES (1650985234156, '2025-06-16 15:00:34', '基于微信小程序的高校餐厅食品留样管理系统', '基于微信小程序的高校餐厅食品留样管理系统', '2025-06-16', 'upload/1650985227606.jpg', '<p><strong style="background-color: rgb(255, 255, 255); color: rgb(0, 73, 142);">基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统</strong></p>');
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='配置文件';

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` (`id`, `name`, `value`) VALUES (1, 'picture1', 'upload/1650985294525.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (2, 'picture2', 'upload/picture2.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (3, 'picture3', 'upload/picture3.jpg');
COMMIT;

-- ----------------------------
-- Table structure for jiaoyuxuanchuan
-- ----------------------------
DROP TABLE IF EXISTS `jiaoyuxuanchuan`;
CREATE TABLE `jiaoyuxuanchuan` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `wenzhangbiaoti` varchar(200) DEFAULT NULL COMMENT '文章标题',
  `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `shipin` varchar(200) DEFAULT NULL COMMENT '视频',
  `bianjiren` varchar(200) DEFAULT NULL COMMENT '编辑人',
  `wenzhangneirong` longtext COMMENT '文章内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985280860 DEFAULT CHARSET=utf8mb3 COMMENT='教育宣传';

-- ----------------------------
-- Records of jiaoyuxuanchuan
-- ----------------------------
BEGIN;
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (81, '2025-06-10 10:11:12', '文章标题1', 'upload/jiaoyuxuanchuan_fengmian1.jpg', '来源1', '2025-06-10 10:11:12', '', '编辑人1', '文章内容1');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (82, '2025-06-11 11:12:13', '文章标题2', 'upload/jiaoyuxuanchuan_fengmian2.jpg', '来源2', '2025-06-11 11:12:13', '', '编辑人2', '文章内容2');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (83, '2025-06-12 12:13:14', '文章标题3', 'upload/jiaoyuxuanchuan_fengmian3.jpg', '来源3', '2025-06-12 12:13:14', '', '编辑人3', '文章内容3');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (84, '2025-06-13 13:14:15', '文章标题4', 'upload/jiaoyuxuanchuan_fengmian4.jpg', '来源4', '2025-06-13 13:14:15', '', '编辑人4', '文章内容4');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (85, '2025-06-14 14:15:16', '文章标题5', 'upload/jiaoyuxuanchuan_fengmian5.jpg', '来源5', '2025-06-14 14:15:16', '', '编辑人5', '文章内容5');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (86, '2025-06-15 15:16:17', '文章标题6', 'upload/jiaoyuxuanchuan_fengmian6.jpg', '来源6', '2025-06-15 15:16:17', '', '编辑人6', '文章内容6');
INSERT INTO `jiaoyuxuanchuan` (`id`, `addtime`, `wenzhangbiaoti`, `fengmian`, `laiyuan`, `fabushijian`, `shipin`, `bianjiren`, `wenzhangneirong`) VALUES (1650985280859, '2025-06-16 16:17:18', '基于微信小程序的高校餐厅食品留样管理系统', 'upload/1650985246979.jpg', '基于微信小程序的高校餐厅食品留样管理系统', '2025-06-16 16:17:18', 'upload/1650985255872.mp4', '李月', '<p><strong style="background-color: rgb(255, 255, 255); color: rgb(0, 73, 142);">基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统基于微信小程序的高校餐厅食品留样管理系统</strong><img src="http://localhost:8080/springbootviu29/upload/1650985274457.jpg"><strong style="background-color: rgb(255, 255, 255); color: rgb(0, 73, 142);">基于微信小程序的高校餐厅食品留样管理系统</strong></p>');
COMMIT;

-- ----------------------------
-- Table structure for liuyangshipin
-- ----------------------------
DROP TABLE IF EXISTS `liuyangshipin`;
CREATE TABLE `liuyangshipin` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
  `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
  `bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜编号',
  `liuyangshijian` datetime DEFAULT NULL COMMENT '留样时间',
  `shipinmingcheng` varchar(200) DEFAULT NULL COMMENT '食品名称',
  `guige` varchar(200) DEFAULT NULL COMMENT '规格',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  `beizhu` longtext COMMENT '备注',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1748938164869 DEFAULT CHARSET=utf8mb3 COMMENT='留样食品';

-- ----------------------------
-- Records of liuyangshipin
-- ----------------------------
BEGIN;
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (51, '2025-06-10 10:11:12', '员工工号1', '窗口编号1', '冰柜编号1', '2025-06-10 10:11:12', '食品名称1', '规格1', 'upload/1650985198740.jpg', '备注1', '是', '武切维奇');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (52, '2025-06-11 11:12:13', '员工工号2', '窗口编号2', '冰柜编号2', '2025-06-11 11:12:13', '食品名称2', '规格2', 'upload/liuyangshipin_tupian2.jpg', '备注2', '是', '');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (53, '2025-06-12 12:13:14', '员工工号3', '窗口编号3', '冰柜编号3', '2025-06-12 12:13:14', '食品名称3', '规格3', 'upload/liuyangshipin_tupian3.jpg', '备注3', '是', '');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (54, '2025-06-13 13:14:15', '员工工号4', '窗口编号4', '冰柜编号4', '2025-06-13 13:14:15', '食品名称4', '规格4', 'upload/liuyangshipin_tupian4.jpg', '备注4', '是', '');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (55, '2025-06-14 14:15:16', '员工工号5', '窗口编号5', '冰柜编号5', '2025-06-14 14:15:16', '食品名称5', '规格5', 'upload/liuyangshipin_tupian5.jpg', '备注5', '是', '');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (56, '2025-06-15 15:16:17', '员工工号6', '窗口编号6', '冰柜编号6', '2025-06-15 15:16:17', '食品名称6', '规格6', 'upload/liuyangshipin_tupian6.jpg', '备注6', '是', '');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (1650985576280, '2025-06-16 16:17:18', '222', '111', '001', '2025-06-16 16:17:18', '鸡腿', '大鸡腿', 'upload/1650985564182.jpg', '22', '是', '通过');
INSERT INTO `liuyangshipin` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `beizhu`, `sfsh`, `shhf`) VALUES (1748938164868, '2025-06-17 17:18:19', '222', '111', '冰柜编号1', '2025-06-17 17:18:19', '123', '23', 'upload/1748938147808.png', '123', '是', '');
COMMIT;

-- ----------------------------
-- Table structure for liuyangshipinxiaohui
-- ----------------------------
DROP TABLE IF EXISTS `liuyangshipinxiaohui`;
CREATE TABLE `liuyangshipinxiaohui` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
  `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
  `bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜编号',
  `liuyangshijian` varchar(200) DEFAULT NULL COMMENT '留样时间',
  `shipinmingcheng` varchar(200) DEFAULT NULL COMMENT '食品名称',
  `guige` varchar(200) DEFAULT NULL COMMENT '规格',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  `xiaohuishijian` datetime DEFAULT NULL COMMENT '销毁时间',
  `xiaohuibeizhu` longtext COMMENT '销毁备注',
  `crossuserid` bigint DEFAULT NULL COMMENT '跨表用户id',
  `crossrefid` bigint DEFAULT NULL COMMENT '跨表主键id',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985636834 DEFAULT CHARSET=utf8mb3 COMMENT='留样食品销毁';

-- ----------------------------
-- Records of liuyangshipinxiaohui
-- ----------------------------
BEGIN;
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (61, '2025-06-10 10:11:12', '员工工号1', '窗口编号1', '冰柜编号1', '留样时间1', '食品名称1', '规格1', 'upload/liuyangshipinxiaohui_tupian1.jpg', '2025-06-10 10:11:12', '销毁备注1', 1, 1, '是', '批准');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (62, '2025-06-11 11:12:13', '员工工号2', '窗口编号2', '冰柜编号2', '留样时间2', '食品名称2', '规格2', 'upload/liuyangshipinxiaohui_tupian2.jpg', '2025-06-11 11:12:13', '销毁备注2', 2, 2, '是', '');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (63, '2025-06-12 12:13:14', '员工工号3', '窗口编号3', '冰柜编号3', '留样时间3', '食品名称3', '规格3', 'upload/liuyangshipinxiaohui_tupian3.jpg', '2025-06-12 12:13:14', '销毁备注3', 3, 3, '是', '');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (64, '2025-06-13 13:14:15', '员工工号4', '窗口编号4', '冰柜编号4', '留样时间4', '食品名称4', '规格4', 'upload/liuyangshipinxiaohui_tupian4.jpg', '2025-06-13 13:14:15', '销毁备注4', 4, 4, '是', '');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (65, '2025-06-14 14:15:16', '员工工号5', '窗口编号5', '冰柜编号5', '留样时间5', '食品名称5', '规格5', 'upload/liuyangshipinxiaohui_tupian5.jpg', '2025-06-14 14:15:16', '销毁备注5', 5, 5, '是', '');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (66, '2025-06-15 15:16:17', '员工工号6', '窗口编号6', '冰柜编号6', '留样时间6', '食品名称6', '规格6', 'upload/liuyangshipinxiaohui_tupian6.jpg', '2025-06-15 15:16:17', '销毁备注6', 6, 6, '是', '');
INSERT INTO `liuyangshipinxiaohui` (`id`, `addtime`, `yuangonggonghao`, `chuangkoubianhao`, `bingjubianhao`, `liuyangshijian`, `shipinmingcheng`, `guige`, `tupian`, `xiaohuishijian`, `xiaohuibeizhu`, `crossuserid`, `crossrefid`, `sfsh`, `shhf`) VALUES (1650985636833, '2025-06-16 16:17:18', '222', '111', '001', '2025-06-16 16:17:18', '鸡腿', '大鸡腿', 'upload/1650985564182.jpg', '2025-06-16 16:17:18', '222', 1650985500525, 1650985576280, '是', '批准');
COMMIT;

-- ----------------------------
-- Table structure for paibanxinxi
-- ----------------------------
DROP TABLE IF EXISTS `paibanxinxi`;
CREATE TABLE `paibanxinxi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',
  `yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
  `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `paibanriqi` date DEFAULT NULL COMMENT '排班日期',
  `zhibanshijian` varchar(200) DEFAULT NULL COMMENT '值班时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650985516486 DEFAULT CHARSET=utf8mb3 COMMENT='排班信息';

-- ----------------------------
-- Records of paibanxinxi
-- ----------------------------
BEGIN;
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (41, '2025-06-10 10:11:12', '窗口编号1', '员工工号1', '员工姓名1', '性别1', '2025-06-10', '值班时间1');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (42, '2025-06-11 11:12:13', '窗口编号2', '员工工号2', '员工姓名2', '性别2', '2025-06-11', '值班时间2');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (43, '2025-06-12 12:13:14', '窗口编号3', '员工工号3', '员工姓名3', '性别3', '2025-06-12', '值班时间3');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (44, '2025-06-13 13:14:15', '窗口编号4', '员工工号4', '员工姓名4', '性别4', '2025-06-13', '值班时间4');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (45, '2025-06-14 14:15:16', '窗口编号5', '员工工号5', '员工姓名5', '性别5', '2025-06-14', '值班时间5');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (46, '2025-06-15 15:16:17', '窗口编号6', '员工工号6', '员工姓名6', '性别6', '2025-06-15', '值班时间6');
INSERT INTO `paibanxinxi` (`id`, `addtime`, `chuangkoubianhao`, `yuangonggonghao`, `yuangongxingming`, `xingbie`, `paibanriqi`, `zhibanshijian`) VALUES (1650985516485, '2025-06-16 16:17:18', '111', '222', '李继军', '男', '2025-06-16', '8:00-12:00');
COMMIT;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='token表';

-- ----------------------------
-- Records of token
-- ----------------------------
BEGIN;
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (1, 1, 'abo', 'users', '管理员', 'fuinsgtsgm32vm98xplx4so05ixe8qr3', '2022-04-26 22:58:02', '2025-06-03 17:11:48');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (2, 1650985355379, '111', 'chuangkoufuzeren', '管理员', 'mgyw56wkp3l036x6jgdleqe64duah4kk', '2022-04-26 23:03:46', '2022-04-27 00:03:46');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (3, 1650985500525, '222', 'chuangkouyuangong', '窗口员工', 'dznu0wmlqvw2bhvrox7asiy4o02un622', '2022-04-26 23:05:32', '2025-06-03 17:07:56');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (4, 21, '员工工号1', 'chuangkouyuangong', '窗口员工', 'tn9kzccv8ygasj6omg3y8ixt6d64z47b', '2022-04-28 17:42:27', '2022-04-28 18:42:28');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `role`, `addtime`) VALUES (1, 'abo', 'abo', '管理员', '2025-06-10 10:11:12');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
